TTN Dashboard

Übersicht (aktuelle Werte)

DDS75-LB

dds75-lb-001

Distance

68.1 cm

Temperature

32.8 °C

dds75-lb-02

Distance

78.5 cm

Temperature

32.8 °C

dds75-lb-03

Distance

85.1 cm

Temperature

32.8 °C

dds75-lb-04

Distance

85.1 cm

Temperature

32.8 °C

dds75-lb-05

Distance

69.7 cm

Temperature

32.8 °C

dds75-lb-06

Distance

68.5 cm

Temperature

32.8 °C

dds75-lb-07

Distance

86.9 cm

Temperature

32.8 °C

dds75-lb-08

Distance

82.9 cm

Temperature

32.8 °C

dds75-lb-09

Distance

0 cm

Temperature

32.8 °C

dds75-lb-10

Distance

71.9 cm

Temperature

32.8 °C

dds75-lb-11

Distance

89.9 cm

Temperature

32.8 °C

dds75-lb-12

Distance

87.1 cm

Temperature

32.8 °C

dds75-lb-13

Distance

92.9 cm

Temperature

32.8 °C

dds75-lb-14

Distance

121.5 cm

Temperature

32.8 °C

dds75-lb-15

Distance

97.7 cm

Temperature

32.8 °C

dds75-lb-16

Distance

71.8 cm

Temperature

32.8 °C

dds75-lb-17

Distance

218.3 cm

Temperature

32.8 °C

dds75-lb-18

Distance

89.7 cm

Temperature

32.8 °C

dds75-lb-19

Distance

68 cm

Temperature

32.8 °C

dds75-lb-20

Distance

92.5 cm

Temperature

32.8 °C

dds75-lb-21

Distance

71.9 cm

Temperature

32.8 °C

PS-LB

ps-lb-01

Water

0 cm

ps-lb-02

Water

18.8 cm

ps-lb-03

Water

20.1 cm

ps-lb-04

Water

19.9 cm

ps-lb-05

Water

22.4 cm

ps-lb-06

Water

20.4 cm

ps-lb-07

Water

20 cm

ps-lb-08

Water

20.8 cm

ps-lb-09

Water

21.9 cm

ps-lb-10

Water

19.5 cm

ps-lb-11

Water

19.2 cm

ps-lb-12

Water

21.9 cm

ps-lb-13

Water

19.6 cm

ps-lb-14

Water

18.1 cm

ps-lb-15

Water

21.1 cm

ps-lb-16

Water

20.2 cm

ps-lb-17

Water

20.6 cm

ps-lb-18

Water

20 cm

ps-lb-19

Water

22.2 cm

ps-lb-20

Water

20 cm

ps-lb-21

Water

21.3 cm

Geräte-Tabelle

device_id	records	last_seen_utc	status
dds75-lb-001	153	2025-09-20 02:43:37Z	ok
dds75-lb-02	151	2025-09-20 02:47:29Z	ok
dds75-lb-03	153	2025-09-20 02:41:38Z	ok
dds75-lb-04	153	2025-09-20 02:44:35Z	ok
dds75-lb-05	153	2025-09-20 02:44:02Z	ok
dds75-lb-06	153	2025-09-20 02:48:18Z	ok
dds75-lb-07	152	2025-09-20 02:44:51Z	ok
dds75-lb-08	153	2025-09-20 02:44:36Z	ok
dds75-lb-09	153	2025-09-20 02:44:38Z	ok
dds75-lb-10	153	2025-09-20 02:45:22Z	ok
dds75-lb-11	153	2025-09-20 02:45:02Z	ok
dds75-lb-12	152	2025-09-20 02:46:05Z	ok
dds75-lb-13	153	2025-09-20 02:47:18Z	ok
dds75-lb-14	153	2025-09-20 02:42:09Z	ok
dds75-lb-15	153	2025-09-20 02:43:07Z	ok
dds75-lb-16	153	2025-09-20 02:40:48Z	ok
dds75-lb-17	153	2025-09-20 02:43:39Z	ok
dds75-lb-18	153	2025-09-20 02:41:17Z	ok
dds75-lb-19	153	2025-09-20 02:45:48Z	ok
dds75-lb-20	151	2025-09-20 02:43:36Z	ok
dds75-lb-21	153	2025-09-20 02:43:46Z	ok
ps-lb-01	400	2025-09-20 02:53:17Z	ok
ps-lb-02	458	2025-09-20 02:50:12Z	ok
ps-lb-03	459	2025-09-20 02:50:21Z	ok
ps-lb-04	457	2025-09-20 02:59:45Z	ok
ps-lb-05	458	2025-09-20 03:00:03Z	ok
ps-lb-06	440	2025-09-20 02:59:43Z	ok
ps-lb-07	457	2025-09-20 02:59:59Z	ok
ps-lb-08	459	2025-09-20 02:59:32Z	ok
ps-lb-09	460	2025-09-20 02:59:30Z	ok
ps-lb-10	460	2025-09-20 03:00:06Z	ok
ps-lb-11	461	2025-09-20 03:00:04Z	ok
ps-lb-12	460	2025-09-20 02:59:35Z	ok
ps-lb-13	2338	2025-09-20 02:32:04Z	ok
ps-lb-14	458	2025-09-20 03:00:10Z	ok
ps-lb-15	460	2025-09-20 03:00:00Z	ok
ps-lb-16	462	2025-09-20 03:00:02Z	ok
ps-lb-17	2548	2025-09-20 03:01:01Z	ok
ps-lb-18	375	2025-09-20 02:52:11Z	ok
ps-lb-19	480	2025-09-20 03:00:35Z	ok
ps-lb-20	482	2025-09-20 02:54:07Z	ok
ps-lb-21	315	2025-09-20 02:59:14Z	ok
sensecap-01	0	NaN	empty

Parquet: data/<device>.parquet • CSV: data/<device>.csv • NDJSON (raw): data/<device>_raw.ndjson

dds75-lb-001

received_at	f_port	battery	rssi	snr
2025-09-20 01:43:38.105725778+00:00	2	3.303	-33	7.00
2025-09-20 02:03:37.861526008+00:00	2	3.303	-33	7.50
2025-09-20 02:23:37.589431215+00:00	2	3.303	-118	-5.80
2025-09-20 02:43:37.383270384+00:00	2	3.303	-35	9.75

dds75-lb-02

received_at	f_port	battery	rssi	snr
2025-09-20 01:47:30.330125235+00:00	2	3.212	-39	10.00
2025-09-20 02:07:30.049939439+00:00	2	3.212	-39	10.25
2025-09-20 02:27:29.769636780+00:00	2	3.212	-118	-2.00
2025-09-20 02:47:29.480188467+00:00	2	3.212	-39	6.50

dds75-lb-03

received_at	f_port	battery	rssi	snr
2025-09-20 01:41:38.799730222+00:00	2	3.29	-119	-3.75
2025-09-20 02:01:38.556509832+00:00	2	3.29	-124	-7.00
2025-09-20 02:21:38.330963811+00:00	2	3.29	-121	-4.50
2025-09-20 02:41:38.092914865+00:00	2	3.29	-44	9.50

dds75-lb-04

received_at	f_port	battery	rssi	snr
2025-09-20 01:44:35.860757332+00:00	2	3.256	-51	9.25
2025-09-20 02:04:35.633686567+00:00	2	3.256	-51	10.25
2025-09-20 02:24:35.372938054+00:00	2	3.256	-50	11.00
2025-09-20 02:44:35.154194676+00:00	2	3.256	-49	7.50

dds75-lb-05

received_at	f_port	battery	rssi	snr
2025-09-20 01:44:03.068383176+00:00	2	3.301	-45	9.25
2025-09-20 02:04:02.823503106+00:00	2	3.301	-114	1.25
2025-09-20 02:24:02.573840526+00:00	2	3.301	-113	0.50
2025-09-20 02:44:02.344905032+00:00	2	3.301	-47	9.50

dds75-lb-06

received_at	f_port	battery	rssi	snr
2025-09-20 01:48:19.039737190+00:00	2	3.343	-39	9.75
2025-09-20 02:08:18.813700496+00:00	2	3.343	-116	0.50
2025-09-20 02:28:18.592478283+00:00	2	3.343	-42	9.50
2025-09-20 02:48:18.357989689+00:00	2	3.343	-120	-4.00

dds75-lb-07

received_at	f_port	battery	rssi	snr
2025-09-20 01:44:51.880204601+00:00	2	3.257	-116	0.50
2025-09-20 02:04:51.629944171+00:00	2	3.257	-36	9.75
2025-09-20 02:24:51.391971059+00:00	2	3.257	-35	9.75
2025-09-20 02:44:51.164678046+00:00	2	3.257	-36	9.25

dds75-lb-08

received_at	f_port	battery	rssi	snr
2025-09-20 01:44:37.560208861+00:00	2	3.28	-34	9.00
2025-09-20 02:04:37.320346039+00:00	2	3.28	-112	4.25
2025-09-20 02:24:37.118043220+00:00	2	3.28	-115	0.75
2025-09-20 02:44:36.876889991+00:00	2	3.28	-35	8.00

dds75-lb-09

received_at	f_port	battery	rssi	snr
2025-09-20 01:44:39.544183596+00:00	2	3.332	-53	9.00
2025-09-20 02:04:39.310682560+00:00	2	3.332	-49	7.25
2025-09-20 02:24:39.083659415+00:00	2	3.332	-46	7.75
2025-09-20 02:44:38.881434374+00:00	2	3.332	-47	7.50

dds75-lb-10

received_at	f_port	battery	rssi	snr
2025-09-20 01:45:23.179598615+00:00	2	3.357	-37	9.75
2025-09-20 02:05:22.920072165+00:00	2	3.357	-37	10.00
2025-09-20 02:25:22.720828302+00:00	2	3.357	-113	2.75
2025-09-20 02:45:22.462533493+00:00	2	3.357	-36	9.00

dds75-lb-11

received_at	f_port	battery	rssi	snr
2025-09-20 01:45:03.418439252+00:00	2	3.299	-122	-7.5
2025-09-20 02:05:03.182489649+00:00	2	3.299	-37	9.5
2025-09-20 02:25:02.960042772+00:00	2	3.299	-35	7.5
2025-09-20 02:45:02.736083766+00:00	2	3.299	-122	-5.0

dds75-lb-12

received_at	f_port	battery	rssi	snr
2025-09-20 01:46:05.870055305+00:00	2	3.314	-45	7.75
2025-09-20 02:06:05.610075198+00:00	2	3.314	-43	9.75
2025-09-20 02:26:05.361051010+00:00	2	3.314	-44	9.50
2025-09-20 02:46:05.132965991+00:00	2	3.314	-43	9.50

dds75-lb-13

received_at	f_port	battery	rssi	snr
2025-09-20 01:47:18.782653872+00:00	2	3.291	-38	9.75
2025-09-20 02:07:18.530323836+00:00	2	3.291	-37	10.75
2025-09-20 02:27:18.282775049+00:00	2	3.291	-35	9.00
2025-09-20 02:47:18.060554830+00:00	2	3.291	-38	9.75

dds75-lb-14

received_at	f_port	battery	rssi	snr
2025-09-20 01:42:09.751866222+00:00	2	3.286	-114	1.00
2025-09-20 02:02:09.528592519+00:00	2	3.286	-119	-7.25
2025-09-20 02:22:09.243471083+00:00	2	3.286	-110	0.20
2025-09-20 02:42:09.061415779+00:00	2	3.286	-111	4.00

dds75-lb-15

received_at	f_port	battery	rssi	snr
2025-09-20 01:43:08.391260274+00:00	2	3.343	-112	3.25
2025-09-20 02:03:08.152670101+00:00	2	3.343	-35	8.75
2025-09-20 02:23:07.902522352+00:00	2	3.343	-37	10.00
2025-09-20 02:43:07.637892989+00:00	2	3.343	-110	4.50

dds75-lb-16

received_at	f_port	battery	rssi	snr
2025-09-20 01:40:48.779820809+00:00	2	3.324	-116	NaN
2025-09-20 02:00:48.544730394+00:00	2	3.324	-48	9.25
2025-09-20 02:20:48.319700088+00:00	2	3.324	-47	7.75
2025-09-20 02:40:48.085474550+00:00	2	3.324	-45	7.25

dds75-lb-17

received_at	f_port	battery	rssi	snr
2025-09-20 01:43:40.354153085+00:00	2	3.277	-37	10.0
2025-09-20 02:03:40.101712155+00:00	2	3.277	-36	10.0
2025-09-20 02:23:39.831388403+00:00	2	3.277	-109	1.8
2025-09-20 02:43:39.629053930+00:00	2	3.277	-36	9.5

dds75-lb-18

received_at	f_port	battery	rssi	snr
2025-09-20 01:41:18.152232786+00:00	2	3.327	-53	10.00
2025-09-20 02:01:17.922989283+00:00	2	3.327	-50	9.25
2025-09-20 02:21:17.703120874+00:00	2	3.327	-50	7.50
2025-09-20 02:41:17.484312921+00:00	2	3.327	-53	7.50

dds75-lb-19

received_at	f_port	battery	rssi	snr
2025-09-20 01:45:49.210555707+00:00	2	3.341	-38	9.50
2025-09-20 02:05:48.980408217+00:00	2	3.341	-41	7.25
2025-09-20 02:25:48.739651427+00:00	2	3.341	-39	9.25
2025-09-20 02:45:48.498978525+00:00	2	3.341	-116	NaN

dds75-lb-20

received_at	f_port	battery	rssi	snr
2025-09-20 01:43:37.292409429+00:00	2	3.268	-124	-9.00
2025-09-20 02:03:37.077095758+00:00	2	3.268	-123	-6.50
2025-09-20 02:23:36.809102024+00:00	2	3.268	-122	-3.50
2025-09-20 02:43:36.623315467+00:00	2	3.268	-42	7.75

dds75-lb-21

received_at	f_port	battery	rssi	snr
2025-09-20 01:43:47.462118024+00:00	2	3.333	-33	10.25
2025-09-20 02:03:47.234795706+00:00	2	3.333	-116	-0.50
2025-09-20 02:23:46.982259022+00:00	2	3.333	-108	3.20
2025-09-20 02:43:46.783388449+00:00	2	3.333	-31	8.75

ps-lb-01

received_at	f_port	battery	rssi	snr
2025-09-20 01:33:18.019123140+00:00	2	3.303	-32	10.00
2025-09-20 01:43:17.879512197+00:00	2	3.303	-30	9.50
2025-09-20 01:53:17.770600001+00:00	2	3.303	-31	10.25
2025-09-20 02:03:17.673369322+00:00	2	3.303	-30	9.25
2025-09-20 02:13:17.578920919+00:00	2	3.303	-29	10.75
2025-09-20 02:23:17.438581823+00:00	2	3.303	-113	-0.25
2025-09-20 02:33:17.325327167+00:00	2	3.303	-31	9.50
2025-09-20 02:43:17.206939104+00:00	2	3.303	-29	10.00
2025-09-20 02:53:17.131605157+00:00	2	3.303	-33	11.50

ps-lb-02

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:30:13.209644918+00:00	2	3.588	18.800	5.504	-21	9.00
2025-09-20 01:40:13.101467429+00:00	2	3.588	18.800	5.504	-24	10.25
2025-09-20 01:50:12.987049222+00:00	2	3.588	18.800	5.504	-24	9.75
2025-09-20 02:00:12.854577959+00:00	2	3.588	18.800	5.504	-23	9.25
2025-09-20 02:10:12.742178320+00:00	2	3.588	18.800	5.504	-120	-6.75
2025-09-20 02:20:12.585877123+00:00	2	3.588	18.788	5.503	-109	5.50
2025-09-20 02:30:12.502833712+00:00	2	3.588	18.800	5.504	-21	7.50
2025-09-20 02:40:12.386318469+00:00	2	3.588	18.800	5.504	-22	8.50
2025-09-20 02:50:12.270314186+00:00	2	3.588	18.800	5.504	-19	9.00

ps-lb-03

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:30:22.558648539+00:00	2	3.576	20.113	5.609	-25	10.50
2025-09-20 01:40:22.419136747+00:00	2	3.582	20.113	5.609	-24	9.50
2025-09-20 01:50:22.302058880+00:00	2	3.582	20.113	5.609	-25	6.75
2025-09-20 02:00:22.198756076+00:00	2	3.582	20.113	5.609	-117	-0.75
2025-09-20 02:10:22.095880894+00:00	2	3.576	20.113	5.609	-116	-1.25
2025-09-20 02:20:21.945047569+00:00	2	3.582	20.113	5.609	-106	3.20
2025-09-20 02:30:21.870229915+00:00	2	3.582	20.113	5.609	-24	7.75
2025-09-20 02:40:21.743084636+00:00	2	3.582	20.113	5.609	-30	6.75
2025-09-20 02:50:21.641910010+00:00	2	3.582	20.113	5.609	-26	10.00

ps-lb-04

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:39:46.669869516+00:00	2	3.576	19.937	5.595	-31	7.25
2025-09-20 01:49:46.540284554+00:00	2	3.582	19.937	5.595	-25	9.75
2025-09-20 01:59:46.441923792+00:00	2	3.582	19.937	5.595	-26	10.50
2025-09-20 02:09:46.309615164+00:00	2	3.582	19.937	5.595	-25	9.50
2025-09-20 02:19:46.162127955+00:00	2	3.582	19.937	5.595	-121	-4.80
2025-09-20 02:29:46.046522279+00:00	2	3.582	19.937	5.595	-121	-5.20
2025-09-20 02:39:45.963162094+00:00	2	3.582	19.937	5.595	-19	7.50
2025-09-20 02:49:45.850132820+00:00	2	3.576	19.937	5.595	-20	10.00
2025-09-20 02:59:45.725023614+00:00	2	3.582	19.925	5.594	-29	7.25

ps-lb-05

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:40:04.792733660+00:00	2	3.588	22.413	5.793	-55	10.00
2025-09-20 01:50:04.660793216+00:00	2	3.588	22.413	5.793	-57	9.50
2025-09-20 02:00:04.560127547+00:00	2	3.588	22.400	5.792	-55	9.50
2025-09-20 02:10:04.430891332+00:00	2	3.588	22.413	5.793	-56	9.50
2025-09-20 02:20:04.297626698+00:00	2	3.588	22.413	5.793	-124	-4.80
2025-09-20 02:30:04.233129730+00:00	2	3.588	22.413	5.793	-55	10.00
2025-09-20 02:40:04.118953743+00:00	2	3.588	22.400	5.792	-54	9.75
2025-09-20 02:50:03.990563160+00:00	2	3.588	22.400	5.792	-57	10.50
2025-09-20 03:00:03.880880761+00:00	2	3.588	22.413	5.793	-56	10.50

ps-lb-06

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:39:44.521278987+00:00	2	3.576	20.362	5.629	-19	9.50
2025-09-20 01:49:44.390102201+00:00	2	3.576	20.375	5.630	-14	9.50
2025-09-20 01:59:44.282080461+00:00	2	3.582	20.375	5.630	-18	7.50
2025-09-20 02:09:44.139748782+00:00	2	3.576	20.375	5.630	-17	7.00
2025-09-20 02:19:43.988001276+00:00	2	3.576	20.375	5.630	-116	-3.50
2025-09-20 02:29:43.869671692+00:00	2	3.582	20.375	5.630	-114	2.20
2025-09-20 02:39:43.773306969+00:00	2	3.576	20.362	5.629	-17	10.75
2025-09-20 02:49:43.655256303+00:00	2	3.576	20.362	5.629	-17	10.00
2025-09-20 02:59:43.512792614+00:00	2	3.576	20.362	5.629	-20	9.75

ps-lb-07

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:40:00.049611170+00:00	2	3.552	20.037	5.603	-21	8.25
2025-09-20 01:49:59.939956394+00:00	2	3.552	20.037	5.603	-23	10.25
2025-09-20 01:59:59.801916661+00:00	2	3.552	20.037	5.603	-26	10.25
2025-09-20 02:09:59.710755740+00:00	2	3.552	20.037	5.603	-21	8.00
2025-09-20 02:19:59.540305934+00:00	2	3.552	20.037	5.603	-122	-8.20
2025-09-20 02:29:59.460888636+00:00	2	3.552	20.037	5.603	-22	9.25
2025-09-20 02:39:59.335671551+00:00	2	3.552	20.037	5.603	-21	10.75
2025-09-20 02:49:59.240601020+00:00	2	3.552	20.037	5.603	-22	9.25
2025-09-20 02:59:59.113739152+00:00	2	3.552	20.037	5.603	-23	10.25

ps-lb-08

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:39:33.549511338+00:00	2	3.570	20.800	5.664	-41	8.75
2025-09-20 01:49:33.429719733+00:00	2	3.564	20.800	5.664	-45	9.75
2025-09-20 01:59:33.313791802+00:00	2	3.570	20.800	5.664	-43	7.75
2025-09-20 02:09:33.191767308+00:00	2	3.570	20.800	5.664	-42	9.00
2025-09-20 02:19:33.052886270+00:00	2	3.570	20.788	5.663	-112	3.00
2025-09-20 02:29:32.928224627+00:00	2	3.564	20.800	5.664	-108	3.80
2025-09-20 02:39:32.825581748+00:00	2	3.570	20.800	5.664	-118	-2.00
2025-09-20 02:49:32.748085126+00:00	2	3.570	20.788	5.663	-120	-6.25
2025-09-20 02:59:32.604203156+00:00	2	3.564	20.788	5.663	-43	9.50

ps-lb-09

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:39:31.208829652+00:00	2	3.546	21.85	5.748	-41	10.25
2025-09-20 01:49:31.079548936+00:00	2	3.552	21.85	5.748	-116	-0.50
2025-09-20 01:59:30.972239453+00:00	2	3.546	21.85	5.748	-41	7.50
2025-09-20 02:09:30.844083014+00:00	2	3.546	21.85	5.748	-39	7.25
2025-09-20 02:19:30.689086272+00:00	2	3.552	21.85	5.748	-112	-2.20
2025-09-20 02:29:30.571112372+00:00	2	3.552	21.85	5.748	-112	2.50
2025-09-20 02:39:30.496909527+00:00	2	3.552	21.85	5.748	-44	10.50
2025-09-20 02:49:30.359883457+00:00	2	3.552	21.85	5.748	-116	-1.00
2025-09-20 02:59:30.241622439+00:00	2	3.552	21.85	5.748	-39	9.75

ps-lb-10

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:40:07.681319644+00:00	2	3.570	19.537	5.563	-43	9.50
2025-09-20 01:50:07.542940361+00:00	2	3.570	19.537	5.563	-44	9.75
2025-09-20 02:00:07.456058823+00:00	2	3.570	19.537	5.563	-44	9.25
2025-09-20 02:10:07.339938335+00:00	2	3.570	19.537	5.563	-43	9.50
2025-09-20 02:20:07.212473660+00:00	2	3.564	19.537	5.563	-39	8.00
2025-09-20 02:30:07.116163331+00:00	2	3.570	19.537	5.563	-43	9.50
2025-09-20 02:40:06.995459417+00:00	2	3.570	19.525	5.562	-43	10.00
2025-09-20 02:50:06.894575544+00:00	2	3.564	19.525	5.562	-44	10.50
2025-09-20 03:00:06.786572469+00:00	2	3.564	19.537	5.563	-45	9.75

ps-lb-11

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:40:05.573312706+00:00	2	3.564	19.25	5.54	-115	0.75
2025-09-20 01:50:05.469504082+00:00	2	3.564	19.25	5.54	-44	10.75
2025-09-20 02:00:05.342803142+00:00	2	3.564	19.25	5.54	-42	8.50
2025-09-20 02:10:05.220005319+00:00	2	3.564	19.25	5.54	-43	9.00
2025-09-20 02:20:05.077600043+00:00	2	3.564	19.25	5.54	-113	3.20
2025-09-20 02:30:04.999744878+00:00	2	3.564	19.25	5.54	-117	-1.50
2025-09-20 02:40:04.865077290+00:00	2	3.564	19.25	5.54	-43	7.25
2025-09-20 02:50:04.762513926+00:00	2	3.564	19.25	5.54	-43	7.25
2025-09-20 03:00:04.642875244+00:00	2	3.564	19.25	5.54	-45	10.75

ps-lb-12

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:39:36.478122385+00:00	2	3.594	21.875	5.750	-115	0.25
2025-09-20 01:49:36.344716358+00:00	2	3.594	21.875	5.750	-35	9.25
2025-09-20 01:59:36.237420592+00:00	2	3.594	21.875	5.750	-114	-1.75
2025-09-20 02:09:36.110678312+00:00	2	3.594	21.875	5.750	-33	10.50
2025-09-20 02:19:35.961847275+00:00	2	3.594	21.875	5.750	-122	-7.00
2025-09-20 02:29:35.884112901+00:00	2	3.594	21.875	5.750	-32	10.00
2025-09-20 02:39:35.752653863+00:00	2	3.594	21.875	5.750	-32	7.50
2025-09-20 02:49:35.650235219+00:00	2	3.600	21.862	5.749	-31	9.50
2025-09-20 02:59:35.521349953+00:00	2	3.594	21.862	5.749	-33	7.00

ps-lb-13

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:32:05.630223178+00:00	2	3.576	19.563	5.565	-120	-8.75
2025-09-20 02:02:05.259766500+00:00	2	3.576	19.563	5.565	-48	9.25
2025-09-20 02:32:04.890674905+00:00	2	3.582	19.563	5.565	-48	9.25

ps-lb-14

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:40:11.721796908+00:00	2	3.57	18.112	5.449	-41	8.00
2025-09-20 01:50:11.623163673+00:00	2	3.57	18.112	5.449	-38	8.75
2025-09-20 02:00:11.491872655+00:00	2	3.57	18.112	5.449	-39	9.75
2025-09-20 02:10:11.380925803+00:00	2	3.57	18.112	5.449	-37	7.75
2025-09-20 02:20:11.231683870+00:00	2	3.57	18.100	5.448	-116	-3.00
2025-09-20 02:30:11.152834728+00:00	2	3.57	18.100	5.448	-38	9.25
2025-09-20 02:40:11.044200637+00:00	2	3.57	18.100	5.448	-38	9.25
2025-09-20 02:50:10.933279587+00:00	2	3.57	18.100	5.448	-41	9.50
2025-09-20 03:00:10.821031329+00:00	2	3.57	18.100	5.448	-41	10.00

ps-lb-15

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:40:01.615951686+00:00	2	3.57	21.088	5.687	-41	9.50
2025-09-20 01:50:01.492146884+00:00	2	3.57	21.075	5.686	-117	-2.50
2025-09-20 02:00:01.363400620+00:00	2	3.57	21.075	5.686	-118	-2.25
2025-09-20 02:10:01.243911892+00:00	2	3.57	21.075	5.686	-38	9.25
2025-09-20 02:20:01.091689476+00:00	2	3.57	21.075	5.686	-120	-7.00
2025-09-20 02:30:00.965192595+00:00	2	3.57	21.075	5.686	-114	0.50
2025-09-20 02:40:00.862671954+00:00	2	3.57	21.075	5.686	-124	-8.00
2025-09-20 02:50:00.764356270+00:00	2	3.57	21.075	5.686	-38	9.50
2025-09-20 03:00:00.643689368+00:00	2	3.57	21.075	5.686	-41	10.00

ps-lb-16

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:50:03.100693396+00:00	2	3.564	20.188	5.615	-39	8.00
2025-09-20 02:00:02.972372565+00:00	2	3.564	20.175	5.614	-39	7.25
2025-09-20 02:10:02.859587807+00:00	2	3.564	20.175	5.614	-39	7.50
2025-09-20 02:20:02.694699053+00:00	2	3.564	20.188	5.615	-114	1.20
2025-09-20 02:30:02.639706921+00:00	2	3.564	20.175	5.614	-42	9.75
2025-09-20 02:40:02.513187490+00:00	2	3.564	20.175	5.614	-39	8.00
2025-09-20 02:50:02.390354414+00:00	2	3.564	20.188	5.615	-118	-2.00
2025-09-20 03:00:02.253473456+00:00	2	3.564	20.175	5.614	-39	9.00

ps-lb-17

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:50:01.642097990+00:00	2	3.546	20.637	5.651	-56	9.25
2025-09-20 02:51:01.644500105+00:00	2	3.546	20.637	5.651	-57	9.50
2025-09-20 02:52:01.622543324+00:00	2	3.546	20.637	5.651	-57	9.50
2025-09-20 02:53:01.609753339+00:00	2	3.546	20.637	5.651	-56	10.25
2025-09-20 02:54:01.601675041+00:00	2	3.546	20.637	5.651	-54	9.25
2025-09-20 02:55:01.591900931+00:00	2	3.546	20.637	5.651	-55	8.75
2025-09-20 02:56:01.583967180+00:00	2	3.546	20.637	5.651	-54	9.50
2025-09-20 02:57:01.591987234+00:00	2	3.546	20.637	5.651	-57	11.75
2025-09-20 02:58:01.585602694+00:00	2	3.546	20.637	5.651	-55	10.00
2025-09-20 02:59:01.569798557+00:00	2	3.552	20.637	5.651	-119	-3.75
2025-09-20 03:00:01.549931774+00:00	2	3.546	20.637	5.651	-119	-2.50
2025-09-20 03:01:01.523074651+00:00	2	3.546	20.637	5.651	-56	9.75

ps-lb-18

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:32:12.268770170+00:00	2	3.582	20.037	5.603	-31	10.75
2025-09-20 01:42:12.152114661+00:00	2	3.576	20.037	5.603	-115	-0.25
2025-09-20 01:52:12.026600778+00:00	2	3.582	20.037	5.603	-27	9.00
2025-09-20 02:02:11.902044863+00:00	2	3.582	20.037	5.603	-30	9.75
2025-09-20 02:12:11.794870388+00:00	2	3.582	20.037	5.603	-119	-3.25
2025-09-20 02:22:11.633617253+00:00	2	3.582	20.037	5.603	-109	2.00
2025-09-20 02:32:11.542055419+00:00	2	3.576	20.037	5.603	-29	9.75
2025-09-20 02:42:11.413022230+00:00	2	3.582	20.037	5.603	-31	11.25
2025-09-20 02:52:11.310959371+00:00	2	3.576	20.037	5.603	-31	10.50

ps-lb-19

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:40:36.509189055+00:00	2	3.534	22.188	5.775	-35	8.00
2025-09-20 01:50:36.399639268+00:00	2	3.534	22.188	5.775	-116	-0.25
2025-09-20 02:00:36.281594735+00:00	2	3.534	22.188	5.775	-37	9.75
2025-09-20 02:10:36.171459489+00:00	2	3.534	22.188	5.775	-36	7.50
2025-09-20 02:20:36.081332466+00:00	2	3.534	22.188	5.775	-116	-1.25
2025-09-20 02:30:35.940620010+00:00	2	3.534	22.175	5.774	-33	10.25
2025-09-20 02:40:35.805183218+00:00	2	3.534	22.175	5.774	-35	7.00
2025-09-20 02:50:35.703400385+00:00	2	3.534	22.188	5.775	-35	9.75
2025-09-20 03:00:35.571571048+00:00	2	3.534	22.188	5.775	-33	7.75

ps-lb-20

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:34:08.418569500+00:00	2	3.594	19.825	5.586	-41	7.00
2025-09-20 01:44:08.310549583+00:00	2	3.594	19.875	5.590	-40	9.00
2025-09-20 01:54:08.211315019+00:00	2	3.594	19.875	5.590	-43	9.25
2025-09-20 02:04:08.070662983+00:00	2	3.594	19.913	5.593	-39	7.00
2025-09-20 02:14:07.953592003+00:00	2	3.594	19.825	5.586	-115	0.75
2025-09-20 02:24:07.804257833+00:00	2	3.594	19.750	5.580	-117	-2.00
2025-09-20 02:34:07.750645797+00:00	2	3.594	19.725	5.578	-119	-3.00
2025-09-20 02:44:07.603581649+00:00	2	3.594	19.850	5.588	-43	10.25
2025-09-20 02:54:07.510961834+00:00	2	3.594	20.012	5.601	-41	9.75

ps-lb-21

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 01:39:15.309344042+00:00	2	3.582	21.350	5.708	-35	10.00
2025-09-20 01:49:15.200864866+00:00	2	3.582	21.350	5.708	-114	1.00
2025-09-20 01:59:15.091873426+00:00	2	3.582	21.350	5.708	-32	7.75
2025-09-20 02:09:14.980643291+00:00	2	3.582	21.350	5.708	-35	10.00
2025-09-20 02:19:14.836057088+00:00	2	3.582	21.350	5.708	-114	3.00
2025-09-20 02:29:14.734585670+00:00	2	3.582	21.350	5.708	-115	-0.50
2025-09-20 02:39:14.665891219+00:00	2	3.582	21.350	5.708	-35	10.50
2025-09-20 02:49:14.546814400+00:00	2	3.582	21.337	5.707	-115	-6.50
2025-09-20 02:59:14.461772937+00:00	2	3.582	21.337	5.707	-35	9.75

sensecap-01

no recent data

Allgemeine Formate im Repo

NDJSON (Newline Delimited JSON)

Jede Zeile ein JSON-Objekt → ideal für Streaming & APIs.
Direkt auswertbar mit jq, pandas.read_json(..., lines=True), jsonlite::stream_in().

# bash / jq
head -n 3 data/<device>_raw.ndjson | jq .
# Python / pandas
import pandas as pd
df = pd.read_json("data/<device>_raw.ndjson", lines=True)

Hinweis: data/<device>_raw.ndjson enthält die rohen TTN-Storage-Antworten pro Pull (optional append/snapshot).

Parquet

Spaltenorientiert, binär, sehr kompakt & schnell.
Für Analysen/Abfragen optimiert – Standard in Spark, DuckDB, BigQuery etc.

# Python / pandas
import pandas as pd
df = pd.read_parquet("data/<device>.parquet")

Typischer Workflow: Rohdaten zuerst als NDJSON persistieren → für Analyse/Archiv in Parquet konvertieren.

CSV

Mensch- & toollesbar, maximal interoperabel (Excel, R, GIS, Shell).
Wird vom Script zusätzlich zu Parquet erzeugt: data/<device>.csv.

# Python / pandas (mit Timestamps)
import pandas as pd
df = pd.read_csv("data/<device>.csv", parse_dates=["received_at"])
# Schnellblick (Shell)
head -n 3 data/<device>.csv

Hinweis: Das Script **liest bevorzugt Parquet** (Performance). CSV dient als offenes Austauschformat und Fallback.

Sensoren & Felder

Sensor	Wichtige Felder
DDS75-LB (`dds75-lb-*.parquet`)	`distance_cm` (bzw. `Distance_mm`), `temperature`, `battery`, Flags: `interrupt_flag`, `sensor_flag`
PS-LB (`burgwald-ps-lb-*.parquet`)	`water_cm` bzw. `pressure_kpa`/`pressure_mpa`, zusätzlich `idc_input_ma`, `vdc_input_v`, `battery`, digitale Eingänge
SenseCAP (`burgwald-sensecap-*.parquet`)	`temperature`, `humidity`, `pressure_hpa`, `illumination`, ggf. `uv_index`, `wind_speed`, `wind_dir`, `rainfall`

Hinweis: Das Dashboard gruppiert Devices automatisch nach Sensor-Typ und zeigt Betriebswerte (Battery/RSSI/SNR/Power) in einem Sammel-Diagramm.

TTN Dashboard – Grouped by Sensor Type

Übersicht (aktuelle Werte)

DDS75-LB

dds75-lb-001

dds75-lb-02

dds75-lb-03

dds75-lb-04

dds75-lb-05

dds75-lb-06

dds75-lb-07

dds75-lb-08

dds75-lb-09

dds75-lb-10

dds75-lb-11

dds75-lb-12

dds75-lb-13

dds75-lb-14

dds75-lb-15

dds75-lb-16

dds75-lb-17

dds75-lb-18

dds75-lb-19

dds75-lb-20

dds75-lb-21

PS-LB

ps-lb-01

ps-lb-02

ps-lb-03

ps-lb-04

ps-lb-05

ps-lb-06

ps-lb-07

ps-lb-08

ps-lb-09

ps-lb-10

ps-lb-11

ps-lb-12

ps-lb-13

ps-lb-14

ps-lb-15

ps-lb-16

ps-lb-17

ps-lb-18

ps-lb-19

ps-lb-20

ps-lb-21

Geräte-Tabelle

DDS75-LB

dds75-lb-001

dds75-lb-02

dds75-lb-03

dds75-lb-04

dds75-lb-05

dds75-lb-06

dds75-lb-07

dds75-lb-08

dds75-lb-09

dds75-lb-10

dds75-lb-11

dds75-lb-12

dds75-lb-13

dds75-lb-14

dds75-lb-15

dds75-lb-16

dds75-lb-17

dds75-lb-18

dds75-lb-19

dds75-lb-20

dds75-lb-21

PS-LB

ps-lb-01

ps-lb-02

ps-lb-03

ps-lb-04

ps-lb-05

ps-lb-06

ps-lb-07

ps-lb-08

ps-lb-09

ps-lb-10